*Input ILO wages and labour costs: 

frame create lab_wages
frame change lab_wages

import delimited "$root/Data/Original/ILO_wages.csv", encoding(UTF-8) clear

kountry ref_arealabel, from(other) stuck

rename _ISO3N_ country_iso3_n

kountry country_iso3_n, from(iso3n) to(iso3c)

replace _ISO3C_="CZE" if ref_arealabel=="Czechia"
replace _ISO3C_="TUR" if ref_arealabel=="Türkiye"

rename obs_value hourly_wage

rename time year

rename _ISO3C_ Prod_country_iso3

drop if missing(Prod_country_iso3)

*Save the dataset: 
save "$root/Data/Original/ILO_wages.dta", replace

frame create lab_costs_unit
frame change lab_costs_unit

import delimited "$root/Data/Original/ILO_lab_costs.csv", encoding(UTF-8) clear

kountry ref_arealabel, from(other) stuck

rename _ISO3N_ country_iso3_n

kountry country_iso3_n, from(iso3n) to(iso3c)

replace _ISO3C_="CZE" if ref_arealabel=="Czechia"
replace _ISO3C_="TUR" if ref_arealabel=="Türkiye"


rename time year
rename _ISO3C_ Prod_country_iso3

drop if missing(Prod_country_iso3)

rename obs_value unit_labor_costs

*Save the dataset: 

save "$root/Data/Original/ILO_labcosts.dta", replace

